UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pUlkFIao+/jd878+ouWSBZFOO+Z2A70X9aHmtYhR1gE='
WHERE
key_id = '54fd92edcf7606665e468ad44352f4abe872cb36c64dadbe033fa963200b4939'
AND (
token = 'pUlkFIao+/jd878+ouWSBZFOO+Z2A70X9aHmtYhR1gE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)