UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'd4qS2p2YXUViqItKwGrbc+Dv1Np3kY6Jv+54cvWSb+E='
WHERE
key_id = '4ff8ac36fdedfb9043e3b3bc149b97d037c644e809be42c13d2239aec017b25c'
AND (
token = 'd4qS2p2YXUViqItKwGrbc+Dv1Np3kY6Jv+54cvWSb+E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)