UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bIKtf8eakiWLG0dW1/CCKZaA23Or1xXuNaVSm81p3NI='
WHERE
key_id = '29a6778cd3e2732b46aae11a11f71b45f6d90f923f18c0d4cc76ee1786fd2f8a'
AND (
token = 'bIKtf8eakiWLG0dW1/CCKZaA23Or1xXuNaVSm81p3NI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)