UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'In6IYAH422LJbrRqpLnuVMMc4JcGOtv4Pk1KAOPbs9w='
WHERE
key_id = 'cbb78b308983c90fa3a363c3d7d6bf26affce9d0b6d460b1fabb17485ed04f68'
AND (
token = 'In6IYAH422LJbrRqpLnuVMMc4JcGOtv4Pk1KAOPbs9w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)