UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lGYUvSvBmr5lcDCmJ1im2WZfwoEki8XRFYeriNqKuR0='
WHERE
key_id = '16bd471fe2f308a8a3b2a49eb0e41f67c599e86d29a2da7cfc8bb4c0fd5d8879'
AND (
token = 'lGYUvSvBmr5lcDCmJ1im2WZfwoEki8XRFYeriNqKuR0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)