UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Xtpylsf537Ol4iVWzBbvBbOGGXIM42EmBcshUO2Sk+E='
WHERE
key_id = '399c143ebfd1da8a5c60c438535161abce32b78f9297df5430d207e90c68ad9f'
AND (
token = 'Xtpylsf537Ol4iVWzBbvBbOGGXIM42EmBcshUO2Sk+E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)