UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9cU7qhO82UmkeFrlU/UEzQRuZqSx59XmQ2HVShZ74io='
WHERE
key_id = '123f8fcef571ce0a206be22826196fe357470920ab766087048368bb7fd7a7fc'
AND (
token = '9cU7qhO82UmkeFrlU/UEzQRuZqSx59XmQ2HVShZ74io='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)