UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pOd5Bj0zAIEdpg1QM2hLk89nHSZfa4gc/wnO2ztpwLw='
WHERE
key_id = '543111a4080ff532e70c59108a2d80ad451baf31127b729adea3993530b19d16'
AND (
token = 'pOd5Bj0zAIEdpg1QM2hLk89nHSZfa4gc/wnO2ztpwLw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)