UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YC3DF/xCbWvKKhG8FOr0gEZRNwYXONJL+QLOPN867Qs='
WHERE
key_id = '1a42ae877d058ac00d616cf4767ba6fe5028ef3201cb181de15d4dcb0581d8f5'
AND (
token = 'YC3DF/xCbWvKKhG8FOr0gEZRNwYXONJL+QLOPN867Qs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)