UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BigxT5C7rsD+o1f3mnS5UnRmBn2LnSvjFLZ90YXdxy8='
WHERE
key_id = '1c1c78583783daad4c17ee2f8482c933e0d5c200d23c4277c754a67c3011ed20'
AND (
token = 'BigxT5C7rsD+o1f3mnS5UnRmBn2LnSvjFLZ90YXdxy8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)