UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W36KaZb64UkwA+DbLuk+0m8jWrlBeaUNga3pWeo4JSo='
WHERE
key_id = '40546c531cfea7c39e70f09d24b1affdf2c2c3dd6733197989f847bade773ad1'
AND (
token = 'W36KaZb64UkwA+DbLuk+0m8jWrlBeaUNga3pWeo4JSo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)