UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fZQ7dBRGgWdFWTO5Az8Ty+C2BbZpdm89Tt+pfPdaywU='
WHERE
key_id = 'be2a63f02dc25d015a0c6827a7c21675e8a2137dec60dd48fb87eab1d09393c3'
AND (
token = 'fZQ7dBRGgWdFWTO5Az8Ty+C2BbZpdm89Tt+pfPdaywU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)