UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '31I9dcju2P9OstOFC0orKkugi7nLVKq4XhResvhY4cQ='
WHERE
key_id = 'e5e6536b926f8abb885e98e48ddff6e163ac2a80518360ac1bfba6c8f366855a'
AND (
token = '31I9dcju2P9OstOFC0orKkugi7nLVKq4XhResvhY4cQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)