UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CT7SGtO1bbTi/N0drQabkwmjA87fE2EOWt3FbDi3b8c='
WHERE
key_id = '76bca284c967feb94cc99080234254d4f6717673c02afc115ad3df9f40646928'
AND (
token = 'CT7SGtO1bbTi/N0drQabkwmjA87fE2EOWt3FbDi3b8c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)