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