UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2ZhTUBl2l2BR/RH93ynI+NiMhzkeJO01QdTI56upKkc='
WHERE
key_id = '8cb1688d727a7d254d772022f3708dac0514013dc7d3893f1da0305b69bd427f'
AND (
token = '2ZhTUBl2l2BR/RH93ynI+NiMhzkeJO01QdTI56upKkc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)