UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1pfk6NaaZz42ms790voGCrtLcOQK4/vo6UrpS11CG98='
WHERE
key_id = 'a9a010748b1e42d708a23dcda05f541b30521f505876a08b81cd1ce9f5d1b392'
AND (
token = '1pfk6NaaZz42ms790voGCrtLcOQK4/vo6UrpS11CG98='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)