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