UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YgNS48JSEPdPjYPEsmdWVWXSAGAHVnY6FZ8ausNSbHA='
WHERE
key_id = 'ecafd3d4268ef29b29431a6dd95f15abd31e9ad3afb0932ed5817027771a8e4c'
AND (
token = 'YgNS48JSEPdPjYPEsmdWVWXSAGAHVnY6FZ8ausNSbHA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)