UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'b8ubC0MK2glQpb2iA3Mb12aRq4S3V/ay+YwJCeGz3UY='
WHERE
key_id = 'a5a16413ef002407628b220fd897321121d8c1abc2302b13fb78218edc064c17'
AND (
token = 'b8ubC0MK2glQpb2iA3Mb12aRq4S3V/ay+YwJCeGz3UY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)