UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9uYAHJx33ZFyS1J3h4Fz1i2CdW949V1uBiiNe4/cQxU='
WHERE
key_id = '3fd8803c7a8b732ed961ab94c6a42a8c721a6cdb436cb783138969c921589f31'
AND (
token = '9uYAHJx33ZFyS1J3h4Fz1i2CdW949V1uBiiNe4/cQxU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)