UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5PXTlhEskJCG7e3xoUjRCvf1jf32ugNlG5ZpL/sJRH0='
WHERE
key_id = '0e1436ae53dd524aecbd9c0e1d2072f81983d1616d77539e18b7fc79052fd94f'
AND (
token = '5PXTlhEskJCG7e3xoUjRCvf1jf32ugNlG5ZpL/sJRH0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)