UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1pBLOx3cr6uJySXZJhRDG+0xv6keovF4Ov3bqLiY4Ak='
WHERE
key_id = '1ef38865a5b03444ad64779929fdbb6b1dbbe764155b6afdcd786119e5bc9a81'
AND (
token = '1pBLOx3cr6uJySXZJhRDG+0xv6keovF4Ov3bqLiY4Ak='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)