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