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