UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fHmKpspvwSrjfklvfPgSmFFUoXdRr79I74bSJAwfBYQ='
WHERE
key_id = '5ccf8912c91e7c058958ddf25e9f4410b0507655fc6d65d15a4ef0feaf79a510'
AND (
token = 'fHmKpspvwSrjfklvfPgSmFFUoXdRr79I74bSJAwfBYQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)