UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C7sKiH8uuiOypNeAf4k33TvjnagT2aFwPiSLiNeW93U='
WHERE
key_id = '577d31ca57a203cc60dc5854d61a6addcdd194d3436892b2e4f8acb4a685a7ec'
AND (
token = 'C7sKiH8uuiOypNeAf4k33TvjnagT2aFwPiSLiNeW93U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)