UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xvRKH/P/1G10e69xE7PQMBunvd0Cp7qRq0DAUlbCec4='
WHERE
key_id = '5e31d363b2859b26d56801930ada7a80195047a61ec80bdfea2b22c04bd4e14a'
AND (
token = 'xvRKH/P/1G10e69xE7PQMBunvd0Cp7qRq0DAUlbCec4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)