UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z6Np07DkPwc4iDJzD5/bno+wm0Y7OSDXnZzAW0v5qas='
WHERE
key_id = '2e1b3eb8b389c81ce81cf502a42856540209bf9591e12365b3e2c76a19d85ffc'
AND (
token = 'z6Np07DkPwc4iDJzD5/bno+wm0Y7OSDXnZzAW0v5qas='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)