UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0gbd4xHMqKce0k1MZ9aj/hhcgr7MNOz1Gs965A9a464='
WHERE
key_id = '5b4167744ac2691bb611eac4959545e547cc82505edd54ef3d2edce3d5c27f1d'
AND (
token = '0gbd4xHMqKce0k1MZ9aj/hhcgr7MNOz1Gs965A9a464='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)