UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pJ31+D3lZQXv9KUgk+7zDKQYpLlICb47EPaLy0ratmM='
WHERE
key_id = 'ca16905fd8685ff3cd786e8d355b87210f75748e398b83a0ee70fa2e726d2809'
AND (
token = 'pJ31+D3lZQXv9KUgk+7zDKQYpLlICb47EPaLy0ratmM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)